How to: Update links.
Solution:
Select 'Links...' from the 'Edit' menu and select the link to update from the 'Links' dialog box. Select the desired updating option. Click 'OK' when completed.
1) Open the workbook containing the link to update.
2) Select the 'Edit' menu and select 'Links...'. (The Links dialog box appears.)
3) Select the link to be updated in the list box.
4) Specify the updating options:
Specifying the options
a) Select the 'Automatic' or the 'Manual' radio button to specify whether to have Excel update the link automatically or to update the link manually.
b) Click 'Update Now' to update the link manually and immediately.
c) Click 'Open Source' to open the source file for editing.
d) Click 'Change Source...' to change the path or filename of the link.
5) Click 'OK'.
